    ALTER MATERIALIZED VIEW
      [ schema. ](materialized_view)
      [ physical_attributes_clause
      | table_compression
      | LOB_storage_clause
        [, LOB_storage_clause ]...
      | modify_LOB_storage_clause
        [, modify_LOB_storage_clause ]...
      | alter_table_partitioning
      | parallel_clause
      | logging_clause
      | allocate_extent_clause
      | shrink_clause
      | { CACHE | NOCACHE }
      ]
      [ alter_iot_clauses ]
      [ USING INDEX physical_attributes_clause ]
      [ MODIFY scoped_table_ref_constraint
      | alter_mv_refresh
      ]
      [ { ENABLE | DISABLE } QUERY REWRITE
      | COMPILE
      | CONSIDER FRESH
      ] ;